Item Set Search Dialog

Used to set up or update a search for items in the design. Also used to save queries and open previously saved queries.

You can access this dialog from the following:

Item Sets dialog: click the Search for Items icon

Setting	Description
New	Clears the fields for the start of a new query.
Open	Opens a dialog from which you can select a previously saved query (.ecquery.xml).
Save	Saves the query with an .ecquery.xml file extension. The ITEMSET QUERY <itemset name> key-in lets you specify a file name for the saved query. `ITEMSET` `QUERY` `<itemset name>`
Search For	The Search For section defines the item or object that will be queried. Select an item from the list or enter the item name directly into the field. As characters are typed into the field, a filtered list of items displays. Double-click an item to add it to the query. The query form supports querying for items with common properties or multiple types of items. These types of queries are called property-based queries and are initiated when either <Items by common properties> or <Multiple types of items> is selected from the Search For option menu. If <Items by common properties> or <Multiple types of items> is selected in the Search For field, the Add or Remove Items dialog opens, which allows you to add or remove items from the search. You get the same result by clicking Items in the Search Summary section of the dialog.
Include item subtypes in results	Clicking this icon causes the query to return items of the type selected in the Search For section as well as any of its subitems.
Where (drop-down)	The drop-down menu displays the option of searching by property or relationship information. When Property value is … is selected, you can enter item property information and conditions related to the search. When Related item is … is selected, you can add relationship information between items to the query.
<name>	The drop-down menu alphabetically displays the properties available. You can enter the first letter of the property you want to select and you will be taken to the first instance of the property that begins with the letter selected. Pressing the same letter repeatedly causes you to skip from one property to the next one that starts with that letter.
<condition>	The drop-down menu displays the operator choices. Most of the operators are commonly known except for "in," "like," and "not in." "In" means the value of the selected property falls within the specified string. "Like" is similar to "equal to" except that it takes the wildcard characters * (asterisk) for multiple characters and % (percent) for a single character. The "equal to" operator is required when the property value actually contains one of the wildcard characters. When you select "not in," an ellipses (…) button displays. Click this button to open the Create list of values dialog, which allows you to create a list of values that you do not want included in the search. Once you add (or remove) the values you want to exclude and click OK, the excluded values display in the value field of the Search dialog.
<value>	Type a value in the field.
Where (button)	(available when Related item is … is selected from the Where drop-down) Opens the Create Where Clause dialog, which allows you to add the conditional information to the relationship.
Add to Search	Adds the criteria to the Search Summary box at the bottom of the dialog. When Edit is selected in the Search Summary box, Accept and Cancel options replace Add to Search.
Clear	Clears the fields in the Where section for a new query.
Group	Allows you to group the search criteria. To group one or more conditions, first select contiguous conditions in the search summary, then click the Group button. Beginning and ending parenthesis are added to the group. Nested grouping is supported.
Ungroup	Allows you to ungroup the search criteria. To ungroup, select either the starting or ending group parenthesis. All of the group's conditions are highlighted. Click the Ungroup button. The beginning and ending parenthesis of the group are removed. Removing nested grouping is supported.
Remove	Allows you to delete search criteria. To remove a condition, select a condition in the search summary, and click the Remove button. If the last remaining condition of a group is removed from a group, the group is automatically removed.
Edit	Allows you to edit the search criteria. To edit a condition, select a condition in the search summary, then click the Edit button. The panel that originally generated the condition displays in the Where section with the appropriate fields populated. Modify the conditional information in the panel, click Accept in the Where section, and the new values are shown in the search summary.
Move up	Moves up one condition at a time. Select a condition in the search summary, then drag the selected condition to the desired location. An insertion line displays while dragging the condition to indicate the location of the condition once dropped. You can also move a condition by selecting it in the search summary, then click the Move Up button. If the last remaining condition of a group is moved out of a group, the group is automatically removed after the move operation.
Move down	Moves down one condition at a time. Select a condition in the search summary, then drag the selected condition to the desired location. An insertion line displays while dragging the condition to indicate the location of the condition once dropped. You can also move a condition by selecting it in the search summary, then click the Move Down button.
File > New	Clears the currently displayed query for the start of a new query. The Search For and Conditions sections are cleared, and any conditional information added to the search summary are removed.
File > Open	Opens a previously saved query file. The standard Windows file open dialog displays. The Query Form displays the conditional information in the exact order it was saved.
File > Save	Saves the query to a file. The standard Windows file save dialog displays. Enter a file name with an .ecquery.xml file extension) and save the file.
File > Save As	Saves the query in a different directory with a different name.
File > Close	Closes the dialog.
Tools > Options	Opens the Options dialog which is used to define the default logical operator (And/Or) and customize the appearance of the Query Builder.
Tools > Toolbar	Turns on/off the display of the toolbar at the top of the Search dialog.